Login
Sign up
Courses

Microsoft Excel

Microsoft Excel

Microsoft Excel

Price : 499

Total Duration : 02:15:49
Total Topics : 31

Payment Options

We accept Visa, MasterCard and American Express.

Payment Gateways

We have Instamojo, PayTM, PayPal & Direct Bank Transfer.

Course Description

Microsoft Excel to maintain tabular information.

Course Content

Introduction
00:07:19

Introduction

0:00:38

Tabular Data

0:06:41

Setting up a Workbook
00:15:03

Creating a Workbook

0:04:18

Setting up Work book

0:05:37

Copying Worksheet

0:05:08

Working with Data
00:24:12

Entering Data

0:05:56

Add or Remove Rows or Columns

0:01:40

Entry Features

0:07:14

Pick from Dropdown list

0:01:48

Moving Data

0:02:51

Excel Table

0:04:43

Calculations
00:21:52

Calculations

0:03:30

Formula

0:04:35

Copying Formula

0:02:51

Functions

0:04:11

Sales Bill

0:03:26

Sales Bill - Footer

0:03:19

Formatting
00:11:15

Formatting Cells

0:03:03

Changing Workbook Theme

0:01:16

Data Formatting

0:03:25

Conditional Highlighting

0:03:31

Sorting & Filtering
00:05:12

Filtering

0:03:07

Sorting

0:02:05

Charts
00:09:15

Pie Chart

0:05:39

Line Chart

0:03:36

Mini Projects
00:38:29

Cash Register

0:06:52

EMI Calculator

0:11:46

Grade Calculation

0:03:13

Monthly Budgeting

0:14:59

Address Book

0:01:39

Conclusion
00:03:12

What's next?

0:03:12

Personal assistantce from technology experts.

Rekha

Senior Manager(Development)

(10 years of experience)

Windows, Mobile & Web development

Skype Name: rekha.collectiva.in

Dhivya

Project Delivery Manager

(8 years of experience)

Windows, Mobile & Web development

Skype Name: dhivya.collectiva.in

Gopi

Project Coordinator

(8 years of experience)

Windows, Mobile & Web development

Skype Name: gopi.collectiva.in

Karthick

Senior Developer

(3 years of experience)

Windows, Mobile & Web development

Skype Name: karthick.collectiva.in

Our courses are being used by the leading College and Polytechnic students.